import pandas as pd
import altair as alt
import warnings
import geopandas as gpd
import json
import urllib.request
df = pd.read_csv('security_incidents.csv')
df.head()| Incident ID | Year | Month | Day | Country Code | Country | Region | District | City | UN | ... | Attack context | Location | Latitude | Longitude | Motive | Actor type | Actor name | Details | Verified | Source | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 1997 | 1.0 | NaN | KH | Cambodia | Banteay Meanchey | NaN | NaN | 0 | ... | Unknown | Unknown | 14.070929 | 103.099916 | Unknown | Unknown | Unknown | 1 ICRC national staff killed while working in ... | Archived | Archived |
| 1 | 2 | 1997 | 1.0 | NaN | RW | Rwanda | Northern | Musanze | Ruhengeri | 0 | ... | Raid | Office/compound | -1.499840 | 29.634970 | Unknown | Unknown | Unknown | 3 INGO international (Spanish) staff killed, 1... | Archived | Archived |
| 2 | 3 | 1997 | 2.0 | NaN | TJ | Tajikistan | NaN | NaN | NaN | 4 | ... | Unknown | Unknown | 38.628173 | 70.815654 | NaN | Unknown | Unknown | 3 UN national staff, 1 UN international (Niger... | Archived | Archived |
| 3 | 4 | 1997 | 2.0 | NaN | SO | Somalia | Lower Juba | Kismayo | Kismayo | 0 | ... | Unknown | Unknown | -0.358216 | 42.545087 | Political | Non-state armed group: Regional | Al-Itihaad al-Islamiya | 1 INGO international staff killed by Al ittiha... | Archived | Archived |
| 4 | 5 | 1997 | 2.0 | 14.0 | RW | Rwanda | Kigali | Kigali | Kigali | 1 | ... | Individual attack | Unknown | -1.950851 | 30.061508 | Political | Unknown | Unknown | 1 UN national staff shot and killed in Kigali ... | Archived | Archived |
5 rows × 41 columns